SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:A special opportunity to acquire a generously proportioned, privately situated, carefully maintained home in Hanover, NH. In 1989, a business owner and Dartmouth alum collaborated with a noted architect to construct a thoughtful residence on over 3 acres — just short of the cul-de-sac in a quiet neighborhood, roughly halfway between the Lyme Green and Dartmouth Green. Offered for the first time. This 5-bedroom, 5-bath lends itself to a multiplicity of shared living arrangements. The stucco-clad section of the house centers on a courtyard defined by stone walls. The potential large quarters above the oversized three-car garage might be ideal as an independently accessible space for in-laws or teenagers. There is a further space on the lowest walkout level of the house that has historically been used as an attractive office space. Fireplaces, rarely used in the 35 years, anchor the two separate living rooms. The atriums on each flanking end of the house help to define the unusual aspects of this home. The more dramatic atrium, accessed via the front door, floods, the house with light. The entire interior and exterior were recently painted, and newly installed hardwood floors add a fresh glow to the house. Generous storage space and closets abound. This uncluttered house is entirely appropriate for rapid occupancy and yet lends itself to possible re-imagination by new owners. Enjoy privacy and main highway access to Hanover and Lyme, and I-91 from this singular home.
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.
Description:42 HIGHBRIDGE- Sited in one of the most desirable locales in Lyme, this stunning reproduction colonial is nestled on 21.30 private acres with gorgeous northerly views. The interiors are bright and well-appointed with a sizable chef's kitchen that steps down into a formal dining room surrounded by windows and a walk-out to the landscaped grounds and gardens. Adjoining the kitchen and dining room is an expansive living room with wood-burning fireplace which opens through French doors to a lovely covered porch/patio and in-ground swimming pool. Rounding out the first floor is a light-filled office to the front of the house and a functional laundry/mudroom entry from the breezeway to the attached two-car garage. An en suite primary bedroom with wood-burning stove on the second floor is complemented by two additional bedrooms with a shared bath, while a versatile open space on the uppermost level is perfectly suited for a rec room or additional living space. Above the garage is a generously-sized accessory studio with a kitchenette, 3/4 bath, and its own private entry. The renovated sugar shack is incredible. The grounds are a lovely mixture of landscaped gardens and lawns and curated mixed forest, all of which overlooks the gorgeous long-range vistas. Located just minutes from downtown Lyme and a short drive from Hanover, Dartmouth College, and area schools, this property offers the convenience of proximity coupled with the luxury of privacy. Note: Some photos virtually staged.